﻿CREATE TABLE [dbo].[EmployerAddress] (
    [EmployerId] UNIQUEIDENTIFIER NOT NULL,
    [AddressId]  INT              NOT NULL,
    CONSTRAINT [PK_CompanyAddress] PRIMARY KEY CLUSTERED ([EmployerId] ASC, [AddressId] ASC),
    CONSTRAINT [FK_CompanyAddress_Address] FOREIGN KEY ([AddressId]) REFERENCES [dbo].[Address] ([AddressId]),
    CONSTRAINT [FK_CompanyAddress_Employer] FOREIGN KEY ([EmployerId]) REFERENCES [dbo].[Employer] ([EmployerId])
);



